package com.zhao.dao;

import com.zhao.pojo.Student;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;

@Mapper
public interface StudentDao {
    Student findByStudentID(String StudentID ,String universityID);
    int addStudent(Student student);
    int updateStudent(Student student);

    ///辅导员
    List<Student> findByUniversityIDAndDepartmentIDAndMajorID(String universityID,String departmentID,String majorID);
    List<Student> findByUniversityIDAndDepartmentIDAndMajorIDAndEbickAmountBiggerThan(String universityID,String departmentID,String majorID,int ebickAmount );

    //admin
    List<Student> findAllByUniversityID(String universityID);
    int deleteByStudentID(String studentID,String universityID);


}
